﻿CREATE TABLE [smk].[ssas_trace_log]
(
	[RowNumber] [int] IDENTITY(0,1) NOT NULL,
	[EventClass] [int] NULL,
	[ActivityID] [nvarchar](128) NULL,
	[ApplicationName] [nvarchar](128) NULL,
	[ClientHostName] [nvarchar](128) NULL,
	[ClientProcessID] [int] NULL,
	[ConnectionID] [int] NULL,
	[CurrentTime] [datetime] NULL,
	[NTDomainName] [nvarchar](128) NULL,
	[NTUserName] [nvarchar](128) NULL,
	[RequestID] [nvarchar](128) NULL,
	[SPID] [int] NULL,
	[ServerName] [nvarchar](128) NULL,
	[StartTime] [datetime] NULL,
	[CPUTime] [bigint] NULL,
	[DatabaseName] [nvarchar](128) NULL,
	[Duration] [bigint] NULL,
	[NTCanonicalUserName] [nvarchar](128) NULL,
	[RequestProperties] [ntext] NULL,
	[TextData] [ntext] NULL,
	[Error] [int] NULL,
	[EventSubclass] [int] NULL,
	[SessionID] [nvarchar](128) NULL,
	[Severity] [int] NULL,
	[Success] [int] NULL,
	[EndTime] [datetime] NULL,
	[ObjectID] [nvarchar](128) NULL,
	[ObjectName] [nvarchar](128) NULL,
	[ObjectPath] [nvarchar](128) NULL,
	[ObjectReference] [nvarchar](128) NULL,
	[ObjectType] [int] NULL,
	[ObjectTypeName] [nvarchar](max) NULL,
	[IntegerData] [bigint] NULL,
	[ProgressTotal] [bigint] NULL,
	[JobID] [int] NULL,
	[SessionType] [nvarchar](128) NULL,
	[RequestParameters] [ntext] NULL,
	[BinaryData] [image] NULL,
) ON 
[fg_smk];
go
ALTER TABLE [smk].[ssas_trace_log] ADD PRIMARY KEY CLUSTERED 
(
	[RowNumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,  IGNORE_DUP_KEY = OFF,  ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [fg_smk]
GO